package com.example.football.mapper;


import com.example.football.pojo.People;
import com.example.football.pojo.Peopleliketeam;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface PeopleliketeamMapper {

    @Select("select * from peopleliketeam  where liketeam=#{liketeam} and peopleid=#{peopleid}")
    Peopleliketeam findUserByLiketeam(@Param("peopleid") Integer peopleid,@Param("liketeam") String liketeam);


    @Insert("insert into peopleliketeam values(#{id},#{peopleid},#{liketeam})")
    @Options(useGeneratedKeys = true,keyProperty = "id",keyColumn = "id")
    void insert(Peopleliketeam peopleliketeam);
}
